Download Excel 2013.77-420.TestKing.2018-06-19.14q.vcex

Step 1: Click in a cell to the right of the data.Step 2: Click the INSERT tab, and then the Pictures command.  Step 3: From the Insert Picture dialog box select the Books.jpg file.

Step 1: Click on the picture.Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.  

Step 1: Open the correct worksheet (Summary Worksheet).Step 2: Click in cell B5.Step 3: Click on the insert function button.  Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.  Step 5: In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.  

Step 1: Click cell C7, and the click the Insert Function Button.  Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK.  The function Arguments Dialog box appears:  Step 3: Click on the Section 3 tab (left bottom part of the window).  Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.  Step 5: Copy cell C7 downwards until cell C29.  Result will be like:  

Step 1: Click cell C7, and then Shift-click cell C29Step 2: Click the Name box at the left end of the formula bar. Step 3: Type: Homework. Press ENTER.